MariaDB Crash Course (Shanette Luellen's Library) by Ben Forta

Author:Ben Forta
Language: eng
Format: mobi, epub
Publisher: Addison-Wesley
Published: 2012-02-07T10:00:00+00:00

Using Joins and Join Conditions

Before wrapping up this two chapter discussion on joins, it is worthwhile to summarize some key points regarding joins and their use:

• Pay careful attention to the type of join being used. More often than not, you’ll want an inner join, but there are often valid uses for outer joins, too.

• Make sure you use the correct join condition, or you’ll return incorrect data.

• Make sure you always provide a join condition, or you’ll end up with the Cartesian product.

• You may include multiple tables in a join and even have different join types for each. Although this is legal and often useful, make sure you test each join separately before testing them together. This makes troubleshooting far simpler.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.